<%@ page language="java" import="java.util.*,java.util.Date,java.sql.*,java.text.SimpleDateFormat" pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<jsp:useBean id="db" class="connBean.ConnDB" scope="page" />

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<%=basePath%>">

		<title>欧米购商城-商品详情</title>

		<meta http-equiv="pragma" content="no-cache">
		<meta http-equiv="cache-control" content="no-cache">
		<meta http-equiv="expires" content="0">
		<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
		<meta http-equiv="description" content="This is my page">


		<link rel="stylesheet" href="css/style.css" type="text/css"
			media="all" />
		<!--[if lte IE 6]><link rel="stylesheet" href="css/ie6.css" type="text/css" media="all" /><![endif]-->

		<meta name="keywwords"
			content="Shop Around - Great free html template for on-line shop. Use it as a start point for your on line business. The template can be easily implemented in many open source E-commerce platforms" />
		<meta name="description"
			content="Shop Around - Great free html template for on-line shop. Use it as a start point for your on line business. The template can be easily implemented in many open source E-commerce platforms" />

		<!-- JS -->
		<script src="js/jquery-1.4.1.min.js" type="text/javascript">
</script>
		<script src="js/jquery.jcarousel.pack.js" type="text/javascript">
</script>
		<script src="js/jquery-func.js" type="text/javascript">
</script>
		<!-- End JS -->

		<script>
$(function() {
	var t = $("#text_box");
	$("#add").click(function() {
		t.val(parseInt(t.val()) + 1)
		setTotal();
	})
	$("#min").click(function() {
		t.val(parseInt(t.val()) - 1)
		setTotal();
	})
	function setTotal() {
		$("#total").html((parseInt(t.val()) * 3.95).toFixed(2));
	}
	setTotal();
})
</script>


		<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

	</head>
	<body>
	<style type="text/css">   
/* CSS Document */   

#mytable {   
width: 700px;   
padding: 0;   
margin: 0;   
} 

caption {   
padding: 0 0 5px 0;   
width: 700px;   
font: italic 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;   
text-align: right;   
}   

th {   
font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;   
color: #fff;   
border-right: 1px solid #C1DAD7;   
border-bottom: 1px solid #C1DAD7;   
border-top: 1px solid #C1DAD7;   
letter-spacing: 2px;   
text-transform: uppercase;   
text-align: left;   
padding: 6px 6px 6px 12px;   
background: #8b0000 no-repeat;   
}   
/*power by www.winshell.cn*/   
th.nobg {   
border-top: 0;   
border-left: 0;   
border-right: 1px solid #C1DAD7;   
background: none;   
}   
  
td {   
border-right: 1px solid #C1DAD7;   
border-bottom: 1px solid #C1DAD7;   
background: #fff;   
font-size:11px;   
padding: 6px 6px 6px 12px;   
color: #4f6b72;   
}

th.spec {   
border-left: 1px solid #C1DAD7;   
border-top: 0;   
background: #fff no-repeat;   
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;   
}   

#content {
	float: left;
	width: 920px;
}

#sidebar {
	float: right;
	width: 226px;
}

.search {
	min-height: 700px;
}

.search-addcart {
	width: 100px;
	background: url(images/cart-link.png) no-repeat 0 0;
	border: 0;
	color: #fff;
	height: 27px;
	display: block;
	line-height: 26px;
	cursor: pointer;
	margin: 12px 0 10px 0;
}

#slider {
	height: 700px;
	position: relative;
	overflow: hidden;
	list-style-type: none;
	border: 0
}

#slider-holder {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
	border: 0
}

#slider-holder .jcarousel-clip {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
}

#slider-holder ul {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
	list-style-type: none;
}

#slider-holder ul li {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
	float: left;
}

#slider-nav {
	position: absolute;
	top: 350px;
	left: 120px;
	z-index: 2;
}

#slider-nav a {
	font-size: 0;
	line-height: 0;
	text-indent: -4000px;
	width: 10px;
	height: 10px;
	border: solid 1px #8b0000;
	background: #8b0000;
	float: right;
	margin-right: 5px;
}

#slider-nav a:hover,#slider-nav a.active {
	background: #fff;
}

.datas {
	
}

.datas ul {
	list-style-type: none;
}

.datas ul li {
	position: relative;
	padding: 1px;
	border: solid 1px #dedede;
	float: left;
	width: 955px;
	margin-right: 9px;
	height: 500px;
	overflow: hidden;
}

.datas ul li2 {
	position: relative;
	padding: 1px;
	border: solid 1px #dedede;
	float: left;
	width: 955px;
	margin-right: 9px;
	height: 120px;
	overflow: hidden;
}

.datas ul li.last {
	margin-right: 0;
}
</style>

		<%
			request.setCharacterEncoding("UTF-8");
		%>
		<jsp:include page="customerService.jsp"></jsp:include>
		<!-- Shell -->
		<div class="shell">

			<!-- Header -->
			<div id="header">
				<h1 id="logo">
					<a href="index.jsp">欧米购</a>
				</h1>
				<!-- Cart -->
				<div id="cart" align="center">
					<%
						if (session.getAttribute("username") == null
								|| session.getAttribute("username") == "") {
					%>您好，您还未登录！
					<div class="cl">
						&nbsp;
					</div>
					<a href="login.jsp" class="c2-link">[登录]</a>
					<a href="addUser.jsp" class="c2-link">[免费注册]</a>
					<%
						} else {
					%>欢迎您，<%=session.getAttribute("username")%>
					<a href="logout.jsp" class="c2-link">[退出]</a>
					<div class="cl">
						&nbsp;
					</div>
					<a href="personalData.jsp" class="c2-link">我的欧米购</a>
					<a href="shoppingCart.jsp" class="cart-link">我的购物车</a>
					<%
						}
					%>
				</div>
				<!-- End Cart -->

				<!-- Navigation -->
				<div id="navigation">
					<ul>
						<li>
							<a href="index.jsp">主页</a>
						</li>
						<%
							db.OpenConn();
							db.createStmt();
							String sql = "select * from main_type";
							ResultSet rs = db.Query(sql);
							while (rs.next()) {
						%>
						<li>
							<a href="index_main_Type.jsp?maintype_id=<%=rs.getInt("t_id")%>"><%=rs.getString("t_name")%></a>
						</li>
						<%
							}
							db.closeStmt();
							db.closeConn();
						%>
					</ul>
				</div>
				<!-- End Navigation -->
			</div>
			<!-- End Header -->

			<!-- Main -->
			<div id="main">
				<!-- Content -->
				<div id="content">
				    <!-- Products -->
			<div class="datas">
				<div class="cl" align="center">&nbsp;</div>
				    <ul>
				        <li align="center">
				            <%request.setCharacterEncoding("utf-8");
  int payid=Integer.parseInt(request.getParameter("payid"));
  String address=request.getParameter("address");
  String email=request.getParameter("email");
  SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格
  String date=df.format(new Date());// new Date()为获取当前系统时间
  Random random = new Random(System. currentTimeMillis());
  int order_id=random.nextInt();
  order_id=Math.abs(order_id);
  db.OpenConn();
  db.createStmt();
  
  String allsql="select s.c_id,c.c_level,c.c_name,s.p_id,p.p_name,p.p_description,p.p_image,s.p_price,s.p_number,s.p_lastTime from shoppingcart as s,product as p,customer as c where s.p_id=p.p_id and s.c_id=c.c_id and c.c_name='"+session.getAttribute("username")+"'";
  System.out.println(allsql);
  ResultSet cartDetail=db.Query(allsql);
  float sum=0;int cid=0;int c_level=0;
  while(cartDetail.next())
 {
 cid=cartDetail.getInt("c_id");
 c_level=cartDetail.getInt("c_level");
 float price=cartDetail.getFloat("p_price");
 int quantity=cartDetail.getInt("p_number");
 float allprice=price*quantity;
 sum+=allprice;
 }
 
 if(c_level==1)
 {
 float f=0.9f; 
 float vipprice=sum*0.9f; 
 sum=vipprice;
 }
 
 String insertsql="insert into orders(order_id,pay_id,order_address,order_email,c_id,order_time,order_sum) values("+order_id+","+payid+",'"+address+"','"+email+"',"+cid+",'"+date+"',"+sum+")";
 int result =db.Update(insertsql);
 if(result!=0){
     String insertDetailsql="insert into orderdetails(order_id,p_id,p_price,p_number) select "+order_id+",p_id,p_price,p_number from shoppingcart where c_id="+cid;
     int result2=db.Update(insertDetailsql);
     if(result2!=0)
     {
        String deleteCartsql="delete from shoppingcart where c_id="+cid;
        int result3=db.Update(deleteCartsql);
        if(result3!=0)
        {
            %><font size="4">提交成功,前去<a href="payment.jsp?order_id=<%=order_id %>">支付</a>！</font><%
        }
        else
        {
            %><font size="4">提交失败,<a href="addOrdersAddress.jsp">返回</a>！</font><%
        }

     }
     else
     {
     %><font size="4">提交失败,<a href="addOrdersAddress.jsp">返回</a>！</font><%
     }
 }
 else
 {
%><font size="4">提交失败,<a href="addOrdersAddress.jsp">返回</a>！</font><%
 }
   %>   
                        </li>
                    </ul>
				<div class="cl">&nbsp;</div>
			</div>
			<!-- End Products -->
				</div>
				<!-- End Content -->

			</div>
			<!-- End Main -->
	
	<!-- Side Full -->
	<div class="side-full">
	
		<!-- Text Cols -->
		<div class="cols">
			<div class="cl">&nbsp;</div>
			<div class="col">
				<h3 class="ico ico1">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="col">
				<h3 class="ico ico2">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="col">
				<h3 class="ico ico3">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="col col-last">
				<h3 class="ico ico4">Donec imperdiet</h3>
				<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec imperdiet, metus ac cursus auctor, arcu felis ornare dui.</p>
				<p class="more"><a href="#" class="bul">Lorem ipsum</a></p>
			</div>
			<div class="cl">&nbsp;</div>
		</div>
		<!-- End Text Cols -->
		
	</div>
	<!-- End Side Full -->
	
	<!-- Footer -->
	<div id="footer">
		<p class="left">
			<a href="index.jsp">Home</a>
			<span>|</span>
			<a href="#">Support</a>
			<span>|</span>
			<a href="#">My Account</a>
			<span>|</span>
			<a href="#">The Store</a>
			<span>|</span>
			<a href="#">Contact</a>
		</p>
		<p class="right">
			&copy; 2015 OMEGO Shopping Design by &nbsp;<a href="#" target="_blank" title="The Sweetest CSS Templates WorldWide">欧米购创意小组</a>
		</p>
	</div>
	<!-- End Footer -->
	
</div>	
<!-- End Shell -->
	
	
</body>
</html>
